package project.DAO;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

@Mapper
@Service
public interface homepageDAO {
    @Select("select count(*) from touch where time=#{date}")
    public  int selectTouch(String time);
    @Select("select count(*) from touch")
    public int selectAll();
    @Select("select count(*) from definite where time=#{date}")
    public  int selectDefinite();
    @Select("select count(*) from definite")
    public int selectAll1();
    @Select("select count(distinct name) from materials")
    public int select();
     @Select("select sum(number) from materials")
    public int selectsum();
     @Select("select count(*) from volunteer")
    public int selectvolunteer();
     @Select("select count(*) from doctor")
    public  int selectDoctor();
     @Select("select count(distinct address) from isolate")
    public int selectIsolate();
     @Select("select sum(student) from isolate")
    public  int selectIsolate1();
}
